﻿// Jinx AJAX Framework
// Copyright (C) 2008 Blake Hegerle
//
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.

using System.Data;

namespace Formality.Game.Database
{
    internal class Initialization
    {
        internal static void Initialize(IDbConnection C)
        {
            Exec(C,
                 @" create table if not exists Players 
                    (
                        PlayerId integer not null primary key autoincrement,
                        Problem varchar(32) not null,
                        Name varchar(255) not null unique
                    )");
            Exec(C,
                 @" create table if not exists Submissions 
                    (
                        SubmissionId integer not null primary key autoincrement,
                        PlayerId int not null,
                        ProblemId varchar(32) not null,
                        SubmissionOrder int not null,
                        Proposition varchar(4000) not null
                    )");
        }

        private static void Exec(IDbConnection C, string CmdText)
        {
            using (var Cmd = C.CreateCommand())
            {
                Cmd.CommandText = CmdText;

                Cmd.ExecuteNonQuery();
            }
        }
    }
}